/*
 Navicat Premium Data Transfer

 Source Server         : Mac MySQL
 Source Server Type    : MySQL
 Source Server Version : 80016
 Source Host           : localhost:3306
 Source Schema         : qiniu

 Target Server Type    : MySQL
 Target Server Version : 80016
 File Encoding         : 65001

 Date: 05/11/2023 20:20:02
*/

SET NAMES utf8mb4;
SET FOREIGN_KEY_CHECKS = 0;

-- ----------------------------
-- Table structure for collect
-- ----------------------------
DROP TABLE IF EXISTS `collect`;
CREATE TABLE `collect` (
  `uid` bigint(20) NOT NULL COMMENT '用户主键',
  `vid` bigint(20) NOT NULL COMMENT '视频主键',
  PRIMARY KEY (`uid`,`vid`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_german2_ci;

-- ----------------------------
-- Records of collect
-- ----------------------------
BEGIN;
INSERT INTO `collect` (`uid`, `vid`) VALUES (1, 54);
INSERT INTO `collect` (`uid`, `vid`) VALUES (2, 27);
INSERT INTO `collect` (`uid`, `vid`) VALUES (2, 34);
INSERT INTO `collect` (`uid`, `vid`) VALUES (2, 35);
INSERT INTO `collect` (`uid`, `vid`) VALUES (2, 37);
INSERT INTO `collect` (`uid`, `vid`) VALUES (2, 38);
INSERT INTO `collect` (`uid`, `vid`) VALUES (2, 40);
INSERT INTO `collect` (`uid`, `vid`) VALUES (2, 41);
INSERT INTO `collect` (`uid`, `vid`) VALUES (2, 79);
INSERT INTO `collect` (`uid`, `vid`) VALUES (2, 86);
INSERT INTO `collect` (`uid`, `vid`) VALUES (2, 94);
INSERT INTO `collect` (`uid`, `vid`) VALUES (2, 95);
INSERT INTO `collect` (`uid`, `vid`) VALUES (2, 106);
INSERT INTO `collect` (`uid`, `vid`) VALUES (3, 69);
INSERT INTO `collect` (`uid`, `vid`) VALUES (3, 88);
INSERT INTO `collect` (`uid`, `vid`) VALUES (4, 89);
INSERT INTO `collect` (`uid`, `vid`) VALUES (4, 93);
INSERT INTO `collect` (`uid`, `vid`) VALUES (5, 4);
INSERT INTO `collect` (`uid`, `vid`) VALUES (5, 44);
INSERT INTO `collect` (`uid`, `vid`) VALUES (5, 90);
COMMIT;

-- ----------------------------
-- Table structure for love
-- ----------------------------
DROP TABLE IF EXISTS `love`;
CREATE TABLE `love` (
  `vid` bigint(20) NOT NULL COMMENT '视频主键',
  `uid` bigint(20) NOT NULL COMMENT '用户主键',
  PRIMARY KEY (`vid`,`uid`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_german2_ci;

-- ----------------------------
-- Records of love
-- ----------------------------
BEGIN;
INSERT INTO `love` (`vid`, `uid`) VALUES (5, 2);
INSERT INTO `love` (`vid`, `uid`) VALUES (28, 2);
INSERT INTO `love` (`vid`, `uid`) VALUES (31, 2);
INSERT INTO `love` (`vid`, `uid`) VALUES (33, 2);
INSERT INTO `love` (`vid`, `uid`) VALUES (34, 2);
INSERT INTO `love` (`vid`, `uid`) VALUES (35, 2);
INSERT INTO `love` (`vid`, `uid`) VALUES (37, 2);
INSERT INTO `love` (`vid`, `uid`) VALUES (38, 2);
INSERT INTO `love` (`vid`, `uid`) VALUES (54, 1);
INSERT INTO `love` (`vid`, `uid`) VALUES (62, 1);
INSERT INTO `love` (`vid`, `uid`) VALUES (79, 2);
INSERT INTO `love` (`vid`, `uid`) VALUES (81, 2);
INSERT INTO `love` (`vid`, `uid`) VALUES (84, 3);
INSERT INTO `love` (`vid`, `uid`) VALUES (86, 4);
INSERT INTO `love` (`vid`, `uid`) VALUES (86, 5);
INSERT INTO `love` (`vid`, `uid`) VALUES (88, 3);
INSERT INTO `love` (`vid`, `uid`) VALUES (88, 4);
INSERT INTO `love` (`vid`, `uid`) VALUES (89, 4);
INSERT INTO `love` (`vid`, `uid`) VALUES (90, 5);
INSERT INTO `love` (`vid`, `uid`) VALUES (94, 2);
INSERT INTO `love` (`vid`, `uid`) VALUES (95, 2);
INSERT INTO `love` (`vid`, `uid`) VALUES (97, 5);
INSERT INTO `love` (`vid`, `uid`) VALUES (106, 2);
COMMIT;

-- ----------------------------
-- Table structure for type
-- ----------------------------
DROP TABLE IF EXISTS `type`;
CREATE TABLE `type` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT COMMENT '类别主键',
  `name` varchar(10) CHARACTER SET utf8mb4 COLLATE utf8mb4_german2_ci DEFAULT NULL COMMENT '类别名称',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=13 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_german2_ci;

-- ----------------------------
-- Records of type
-- ----------------------------
BEGIN;
INSERT INTO `type` (`id`, `name`) VALUES (1, '动漫');
INSERT INTO `type` (`id`, `name`) VALUES (2, '搞笑');
INSERT INTO `type` (`id`, `name`) VALUES (3, '编程');
INSERT INTO `type` (`id`, `name`) VALUES (4, '体育运动');
INSERT INTO `type` (`id`, `name`) VALUES (5, '时尚美妆');
INSERT INTO `type` (`id`, `name`) VALUES (6, '情感故事');
INSERT INTO `type` (`id`, `name`) VALUES (7, '萌宠');
INSERT INTO `type` (`id`, `name`) VALUES (8, '游戏');
INSERT INTO `type` (`id`, `name`) VALUES (9, '学习');
INSERT INTO `type` (`id`, `name`) VALUES (10, '恋爱');
INSERT INTO `type` (`id`, `name`) VALUES (11, '音乐');
INSERT INTO `type` (`id`, `name`) VALUES (12, '影视剧');
COMMIT;

-- ----------------------------
-- Table structure for upload
-- ----------------------------
DROP TABLE IF EXISTS `upload`;
CREATE TABLE `upload` (
  `uid` bigint(20) NOT NULL COMMENT '用户主键',
  `vid` bigint(20) NOT NULL COMMENT '视频主键',
  PRIMARY KEY (`vid`,`uid`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_german2_ci;

-- ----------------------------
-- Records of upload
-- ----------------------------
BEGIN;
INSERT INTO `upload` (`uid`, `vid`) VALUES (1, 1);
INSERT INTO `upload` (`uid`, `vid`) VALUES (1, 2);
INSERT INTO `upload` (`uid`, `vid`) VALUES (1, 3);
INSERT INTO `upload` (`uid`, `vid`) VALUES (1, 4);
INSERT INTO `upload` (`uid`, `vid`) VALUES (1, 5);
INSERT INTO `upload` (`uid`, `vid`) VALUES (1, 6);
INSERT INTO `upload` (`uid`, `vid`) VALUES (1, 7);
INSERT INTO `upload` (`uid`, `vid`) VALUES (1, 8);
INSERT INTO `upload` (`uid`, `vid`) VALUES (1, 9);
INSERT INTO `upload` (`uid`, `vid`) VALUES (1, 10);
INSERT INTO `upload` (`uid`, `vid`) VALUES (1, 11);
INSERT INTO `upload` (`uid`, `vid`) VALUES (1, 12);
INSERT INTO `upload` (`uid`, `vid`) VALUES (1, 13);
INSERT INTO `upload` (`uid`, `vid`) VALUES (1, 14);
INSERT INTO `upload` (`uid`, `vid`) VALUES (1, 15);
INSERT INTO `upload` (`uid`, `vid`) VALUES (1, 16);
INSERT INTO `upload` (`uid`, `vid`) VALUES (1, 17);
INSERT INTO `upload` (`uid`, `vid`) VALUES (1, 18);
INSERT INTO `upload` (`uid`, `vid`) VALUES (1, 19);
INSERT INTO `upload` (`uid`, `vid`) VALUES (1, 20);
INSERT INTO `upload` (`uid`, `vid`) VALUES (1, 21);
INSERT INTO `upload` (`uid`, `vid`) VALUES (1, 22);
INSERT INTO `upload` (`uid`, `vid`) VALUES (1, 23);
INSERT INTO `upload` (`uid`, `vid`) VALUES (1, 24);
INSERT INTO `upload` (`uid`, `vid`) VALUES (1, 25);
INSERT INTO `upload` (`uid`, `vid`) VALUES (1, 26);
INSERT INTO `upload` (`uid`, `vid`) VALUES (1, 27);
INSERT INTO `upload` (`uid`, `vid`) VALUES (1, 28);
INSERT INTO `upload` (`uid`, `vid`) VALUES (1, 29);
INSERT INTO `upload` (`uid`, `vid`) VALUES (1, 30);
INSERT INTO `upload` (`uid`, `vid`) VALUES (1, 31);
INSERT INTO `upload` (`uid`, `vid`) VALUES (1, 32);
INSERT INTO `upload` (`uid`, `vid`) VALUES (1, 33);
INSERT INTO `upload` (`uid`, `vid`) VALUES (1, 34);
INSERT INTO `upload` (`uid`, `vid`) VALUES (1, 35);
INSERT INTO `upload` (`uid`, `vid`) VALUES (1, 36);
INSERT INTO `upload` (`uid`, `vid`) VALUES (1, 37);
INSERT INTO `upload` (`uid`, `vid`) VALUES (1, 38);
INSERT INTO `upload` (`uid`, `vid`) VALUES (1, 39);
INSERT INTO `upload` (`uid`, `vid`) VALUES (1, 40);
INSERT INTO `upload` (`uid`, `vid`) VALUES (1, 41);
INSERT INTO `upload` (`uid`, `vid`) VALUES (1, 42);
INSERT INTO `upload` (`uid`, `vid`) VALUES (1, 43);
INSERT INTO `upload` (`uid`, `vid`) VALUES (1, 44);
INSERT INTO `upload` (`uid`, `vid`) VALUES (1, 45);
INSERT INTO `upload` (`uid`, `vid`) VALUES (1, 46);
INSERT INTO `upload` (`uid`, `vid`) VALUES (1, 47);
INSERT INTO `upload` (`uid`, `vid`) VALUES (1, 48);
INSERT INTO `upload` (`uid`, `vid`) VALUES (1, 49);
INSERT INTO `upload` (`uid`, `vid`) VALUES (1, 50);
INSERT INTO `upload` (`uid`, `vid`) VALUES (1, 51);
INSERT INTO `upload` (`uid`, `vid`) VALUES (1, 52);
INSERT INTO `upload` (`uid`, `vid`) VALUES (1, 53);
INSERT INTO `upload` (`uid`, `vid`) VALUES (1, 54);
INSERT INTO `upload` (`uid`, `vid`) VALUES (1, 55);
INSERT INTO `upload` (`uid`, `vid`) VALUES (1, 56);
INSERT INTO `upload` (`uid`, `vid`) VALUES (1, 57);
INSERT INTO `upload` (`uid`, `vid`) VALUES (1, 58);
INSERT INTO `upload` (`uid`, `vid`) VALUES (1, 59);
INSERT INTO `upload` (`uid`, `vid`) VALUES (1, 60);
INSERT INTO `upload` (`uid`, `vid`) VALUES (1, 61);
INSERT INTO `upload` (`uid`, `vid`) VALUES (1, 62);
INSERT INTO `upload` (`uid`, `vid`) VALUES (1, 63);
INSERT INTO `upload` (`uid`, `vid`) VALUES (1, 64);
INSERT INTO `upload` (`uid`, `vid`) VALUES (1, 65);
INSERT INTO `upload` (`uid`, `vid`) VALUES (1, 66);
INSERT INTO `upload` (`uid`, `vid`) VALUES (1, 67);
INSERT INTO `upload` (`uid`, `vid`) VALUES (1, 68);
INSERT INTO `upload` (`uid`, `vid`) VALUES (1, 69);
INSERT INTO `upload` (`uid`, `vid`) VALUES (1, 70);
INSERT INTO `upload` (`uid`, `vid`) VALUES (1, 71);
INSERT INTO `upload` (`uid`, `vid`) VALUES (1, 72);
INSERT INTO `upload` (`uid`, `vid`) VALUES (1, 73);
INSERT INTO `upload` (`uid`, `vid`) VALUES (1, 74);
INSERT INTO `upload` (`uid`, `vid`) VALUES (1, 75);
INSERT INTO `upload` (`uid`, `vid`) VALUES (1, 76);
INSERT INTO `upload` (`uid`, `vid`) VALUES (1, 77);
INSERT INTO `upload` (`uid`, `vid`) VALUES (1, 78);
INSERT INTO `upload` (`uid`, `vid`) VALUES (1, 79);
INSERT INTO `upload` (`uid`, `vid`) VALUES (1, 80);
INSERT INTO `upload` (`uid`, `vid`) VALUES (1, 81);
INSERT INTO `upload` (`uid`, `vid`) VALUES (1, 82);
INSERT INTO `upload` (`uid`, `vid`) VALUES (1, 83);
INSERT INTO `upload` (`uid`, `vid`) VALUES (1, 84);
INSERT INTO `upload` (`uid`, `vid`) VALUES (1, 85);
INSERT INTO `upload` (`uid`, `vid`) VALUES (1, 86);
INSERT INTO `upload` (`uid`, `vid`) VALUES (1, 87);
INSERT INTO `upload` (`uid`, `vid`) VALUES (1, 88);
INSERT INTO `upload` (`uid`, `vid`) VALUES (1, 89);
INSERT INTO `upload` (`uid`, `vid`) VALUES (1, 90);
INSERT INTO `upload` (`uid`, `vid`) VALUES (1, 91);
INSERT INTO `upload` (`uid`, `vid`) VALUES (1, 92);
INSERT INTO `upload` (`uid`, `vid`) VALUES (1, 93);
INSERT INTO `upload` (`uid`, `vid`) VALUES (1, 94);
INSERT INTO `upload` (`uid`, `vid`) VALUES (1, 95);
INSERT INTO `upload` (`uid`, `vid`) VALUES (1, 96);
INSERT INTO `upload` (`uid`, `vid`) VALUES (4, 97);
INSERT INTO `upload` (`uid`, `vid`) VALUES (5, 98);
COMMIT;

-- ----------------------------
-- Table structure for user
-- ----------------------------
DROP TABLE IF EXISTS `user`;
CREATE TABLE `user` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT COMMENT '用户主键',
  `username` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_german2_ci DEFAULT NULL COMMENT '用户名',
  `password` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_german2_ci DEFAULT NULL COMMENT '密码',
  `type` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_german2_ci DEFAULT NULL COMMENT '用户选择的喜欢的类别',
  `email` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_german2_ci DEFAULT NULL COMMENT '邮箱',
  `is_commend` tinyint(4) DEFAULT '0',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=6 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_german2_ci;

-- ----------------------------
-- Records of user
-- ----------------------------
BEGIN;
INSERT INTO `user` (`id`, `username`, `password`, `type`, `email`, `is_commend`) VALUES (1, 'admin', '123456', 'NaN,1,3,4', '277@qq.com', 1);
INSERT INTO `user` (`id`, `username`, `password`, `type`, `email`, `is_commend`) VALUES (5, 'nxy', '111', 'NaN,1,2', '3056412108@qq.com', 0);
COMMIT;

-- ----------------------------
-- Table structure for video
-- ----------------------------
DROP TABLE IF EXISTS `video`;
CREATE TABLE `video` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT COMMENT '视频的主键',
  `key` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_german2_ci DEFAULT NULL COMMENT '视频的key',
  `hash` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_german2_ci DEFAULT NULL COMMENT '视频的hash',
  `type` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_german2_ci DEFAULT NULL COMMENT '视频类型',
  `title` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_german2_ci DEFAULT NULL COMMENT '视频标题',
  `uid` bigint(20) DEFAULT NULL COMMENT '上传该文件的用户ID',
  `cover` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_german2_ci DEFAULT NULL COMMENT '视频文件的封面',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=99 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_german2_ci;

-- ----------------------------
-- Records of video
-- ----------------------------
BEGIN;
INSERT INTO `video` (`id`, `key`, `hash`, `type`, `title`, `uid`, `cover`) VALUES (1, 'lixianhe/1699158773205.mp4', 'Fik11MfA1AYqPjVA7ylt7bNZQl40', '9', '宇哥段子十八', 1, 'lixianhe/1699158773205.jpg');
INSERT INTO `video` (`id`, `key`, `hash`, `type`, `title`, `uid`, `cover`) VALUES (2, 'lixianhe/1699158778464.mp4', 'FsFi17TtVus35tTzv24ugIq_zbB_', '9', '徐涛之你上我下', 1, 'lixianhe/1699158778464.jpg');
INSERT INTO `video` (`id`, `key`, `hash`, `type`, `title`, `uid`, `cover`) VALUES (3, 'lixianhe/1699158780886.mp4', 'FhgGUckgOdEKylHHQdBoyj6XJNQw', '9', '高等数学', 1, 'lixianhe/1699158780886.jpg');
INSERT INTO `video` (`id`, `key`, `hash`, `type`, `title`, `uid`, `cover`) VALUES (4, 'lixianhe/1699158783343.mp4', 'FrODtI4mm5M7d_D_EgTgN3VxvFp3', '9', '这就是考研数学', 1, 'lixianhe/1699158783343.jpg');
INSERT INTO `video` (`id`, `key`, `hash`, `type`, `title`, `uid`, `cover`) VALUES (5, 'lixianhe/1699158788443.mp4', 'FjXmcUZwsNufoUOejIgukrSt0i2g', '9', '宇哥顺口留', 1, 'lixianhe/1699158788443.jpg');
INSERT INTO `video` (`id`, `key`, `hash`, `type`, `title`, `uid`, `cover`) VALUES (6, 'lixianhe/1699158801535.mp4', 'lvrxiGpvmcqHJTCqMIxcTq6TwclB', '11', '烂街经典粤语神曲', 1, 'lixianhe/1699158801535.jpg');
INSERT INTO `video` (`id`, `key`, `hash`, `type`, `title`, `uid`, `cover`) VALUES (7, 'lixianhe/1699158966038.mp4', 'lhnkXZrwaezu6eq5QzHWP79rJY-W', '11', '经典影视原声《只爱西经》', 1, 'lixianhe/1699158966038.jpg');
INSERT INTO `video` (`id`, `key`, `hash`, `type`, `title`, `uid`, `cover`) VALUES (8, 'lixianhe/1699158981586.mp4', 'lsSCvJXu1msxNXnyjQHngaOdA3uc', '11', '二三十年前最流行的经典老歌', 1, 'lixianhe/1699158981586.jpg');
INSERT INTO `video` (`id`, `key`, `hash`, `type`, `title`, `uid`, `cover`) VALUES (9, 'lixianhe/1699159009310.mp4', 'lvKnYODU_AiVZ7kU_ymzJQ1JCMRx', '11', '回顾那些经典好歌', 1, 'lixianhe/1699159009310.jpg');
INSERT INTO `video` (`id`, `key`, `hash`, `type`, `title`, `uid`, `cover`) VALUES (10, 'lixianhe/1699159050845.mp4', 'lqSIS-umm4JgP4zb8mnKVGo8d9OP', '11', '全球公认的世界级金曲', 1, 'lixianhe/1699159050845.jpg');
INSERT INTO `video` (`id`, `key`, `hash`, `type`, `title`, `uid`, `cover`) VALUES (11, 'lixianhe/1699159174513.mp4', 'FqAmzcwWCHWBslZ-kZlvO6hJOZWh', '11', '《夜晚微雨问海棠》', 1, 'lixianhe/1699159174513.jpg');
INSERT INTO `video` (`id`, `key`, `hash`, `type`, `title`, `uid`, `cover`) VALUES (12, 'lixianhe/1699159176682.mp4', 'lnuKS8SiicvmHAFcWKID5MkvY2RB', '11', '盘点五首播放量破亿的网络神曲', 1, 'lixianhe/1699159176682.jpg');
INSERT INTO `video` (`id`, `key`, `hash`, `type`, `title`, `uid`, `cover`) VALUES (13, 'lixianhe/1699159200755.mp4', 'lplD-RgXWrIxCSVHKgkdlfRCJkMv', '11', '99年-84年春晚经典歌曲', 1, 'lixianhe/1699159200755.jpg');
INSERT INTO `video` (`id`, `key`, `hash`, `type`, `title`, `uid`, `cover`) VALUES (14, 'lixianhe/1699159228823.mp4', 'llEBuezOVgZvR69MFYDzH_gi9Z6x', '11', '30首歌带你了解2000年爆火的华语乐坛', 1, 'lixianhe/1699159228823.jpg');
INSERT INTO `video` (`id`, `key`, `hash`, `type`, `title`, `uid`, `cover`) VALUES (15, 'lixianhe/1699159247897.mp4', 'lmTRR2_zC7YDby2mFRLRGbtSkmxT', '11', '周杰伦十大神仙音乐', 1, 'lixianhe/1699159247897.jpg');
INSERT INTO `video` (`id`, `key`, `hash`, `type`, `title`, `uid`, `cover`) VALUES (16, 'lixianhe/1699159276310.mp4', 'ln-he-rY-p7xNPyyEVni3CcHzHDx', '7', '可爱猫狗08', 1, 'lixianhe/1699159276310.jpg');
INSERT INTO `video` (`id`, `key`, `hash`, `type`, `title`, `uid`, `cover`) VALUES (17, 'lixianhe/1699159302637.mp4', 'lh4BrMvdLIzKcBsomR4beBsUCyd2', '7', '可爱猫狗09', 1, 'lixianhe/1699159302637.jpg');
INSERT INTO `video` (`id`, `key`, `hash`, `type`, `title`, `uid`, `cover`) VALUES (18, 'lixianhe/1699159440201.mp4', 'ltu-ZnDt0IYcVSO_aBpSrRMk9oTT', '7', '可爱猫狗02', 1, 'lixianhe/1699159440201.jpg');
INSERT INTO `video` (`id`, `key`, `hash`, `type`, `title`, `uid`, `cover`) VALUES (19, 'lixianhe/1699159458123.mp4', 'lvPcjaFE7b3MUOK5iv--mLUJVMJt', '7', '可爱猫狗03', 1, 'lixianhe/1699159458123.jpg');
INSERT INTO `video` (`id`, `key`, `hash`, `type`, `title`, `uid`, `cover`) VALUES (20, 'lixianhe/1699159477931.mp4', 'lqPVh4Mw9fCsI_vYM7aepDY-Ecwv', '7', '可爱猫狗01', 1, 'lixianhe/1699159477931.jpg');
INSERT INTO `video` (`id`, `key`, `hash`, `type`, `title`, `uid`, `cover`) VALUES (21, 'lixianhe/1699159496458.mp4', 'lmCh75nEkY9H4JxDq8npi04otNHV', '7', '可爱猫狗04', 1, 'lixianhe/1699159496458.jpg');
INSERT INTO `video` (`id`, `key`, `hash`, `type`, `title`, `uid`, `cover`) VALUES (22, 'lixianhe/1699159517755.mp4', 'lnPSFQmPkhPlTY-SPMKnShd2hWy0', '7', '可爱猫狗10', 1, 'lixianhe/1699159517755.jpg');
INSERT INTO `video` (`id`, `key`, `hash`, `type`, `title`, `uid`, `cover`) VALUES (23, 'lixianhe/1699159625386.mp4', 'lmqlpjsDZXjBcc4nHbaiElXaB1ly', '7', '可爱猫狗11', 1, 'lixianhe/1699159625386.jpg');
INSERT INTO `video` (`id`, `key`, `hash`, `type`, `title`, `uid`, `cover`) VALUES (24, 'lixianhe/1699159679899.mp4', 'lpleCnkzrkEQHoCjBlIBYKI72zCz', '7', '可爱猫狗05', 1, 'lixianhe/1699159679899.jpg');
INSERT INTO `video` (`id`, `key`, `hash`, `type`, `title`, `uid`, `cover`) VALUES (25, 'lixianhe/1699159757896.mp4', 'lmqQdRON70MdGUUY3g-Miw5qrzkW', '7', '可爱猫狗07', 1, 'lixianhe/1699159757896.jpg');
INSERT INTO `video` (`id`, `key`, `hash`, `type`, `title`, `uid`, `cover`) VALUES (26, 'lixianhe/1699159797010.mp4', 'lr8JoZIg94xEUYJ82RQY-6lrGayF', '7', '可爱猫狗06', 1, 'lixianhe/1699159797010.jpg');
INSERT INTO `video` (`id`, `key`, `hash`, `type`, `title`, `uid`, `cover`) VALUES (27, 'lixianhe/1699159948420.mp4', 'lm6p_BhFd3MPq2c8pas-7sbTIJ2V', '6', '24岁生孩子和39岁生孩子', 1, 'lixianhe/1699159948420.jpg');
INSERT INTO `video` (`id`, `key`, `hash`, `type`, `title`, `uid`, `cover`) VALUES (28, 'lixianhe/1699160012910.mp4', 'lv8sTTV1DQbjm5RanyUAfECWVm_a', '6', '你穷过吗', 1, 'lixianhe/1699160012910.jpg');
INSERT INTO `video` (`id`, `key`, `hash`, `type`, `title`, `uid`, `cover`) VALUES (29, 'lixianhe/1699160028254.mp4', 'ljOaHx1UUdIMOoZ_dR1IsKsaWZQh', '6', '有孩子的父母看了可不兴哭', 1, 'lixianhe/1699160028254.jpg');
INSERT INTO `video` (`id`, `key`, `hash`, `type`, `title`, `uid`, `cover`) VALUES (30, 'lixianhe/1699160065265.mp4', 'lr2Nm57FD3cWFvna-7uCmNwhnEvx', '6', '乱套了', 1, 'lixianhe/1699160065265.jpg');
INSERT INTO `video` (`id`, `key`, `hash`, `type`, `title`, `uid`, `cover`) VALUES (31, 'lixianhe/1699160072574.mp4', 'lmkUzOZQiBUO1tl3Ux5xPxrE4uAj', '6', '养闺女有啥用啊', 1, 'lixianhe/1699160072574.jpg');
INSERT INTO `video` (`id`, `key`, `hash`, `type`, `title`, `uid`, `cover`) VALUES (32, 'lixianhe/1699160568826.mp4', 'lgTxB_h-Jiu3xzvLyfdcLEWEXT5X', '6', '忠孝二字心中留，莫等父母到白头', 1, 'lixianhe/1699160568826.jpg');
INSERT INTO `video` (`id`, `key`, `hash`, `type`, `title`, `uid`, `cover`) VALUES (33, 'lixianhe/1699160597088.mp4', 'lkPStW2e88RzUR-_I2HLHveG6PQx', '6', '渣男', 1, 'lixianhe/1699160597088.jpg');
INSERT INTO `video` (`id`, `key`, `hash`, `type`, `title`, `uid`, `cover`) VALUES (34, 'lixianhe/1699160624668.mp4', 'lpN0Nsq8dwzktIP3lajze0ZAzPvQ', '1', '神奇宝贝', 1, 'lixianhe/1699160624668.jpg');
INSERT INTO `video` (`id`, `key`, `hash`, `type`, `title`, `uid`, `cover`) VALUES (35, 'lixianhe/1699160693548.mp4', 'llhGzeRA6aRbbcT7z9CNgaexYKCP', '1', '铠甲勇士刑天', 1, 'lixianhe/1699160693548.jpg');
INSERT INTO `video` (`id`, `key`, `hash`, `type`, `title`, `uid`, `cover`) VALUES (36, 'lixianhe/1699160803200.mp4', 'lsnfNZpN5IOJWcM0nL51NGklko9R', '1', '超兽武装', 1, 'lixianhe/1699160803200.jpg');
INSERT INTO `video` (`id`, `key`, `hash`, `type`, `title`, `uid`, `cover`) VALUES (37, 'lixianhe/1699160879344.mp4', 'lqXLbeua4zpYsTI4at4iSNpUiWZl', '1', '盘点童年的日本动画片', 1, 'lixianhe/1699160879344.jpg');
INSERT INTO `video` (`id`, `key`, `hash`, `type`, `title`, `uid`, `cover`) VALUES (38, 'lixianhe/1699161651094.mp4', 'ls05oovl9kl48Lf-GsfBdLkwGNH0', '1', '网球王子', 1, 'lixianhe/1699161651094.jpg');
INSERT INTO `video` (`id`, `key`, `hash`, `type`, `title`, `uid`, `cover`) VALUES (39, 'lixianhe/1699161670523.mp4', 'lrdhVPPgaJ3_YUeuNXgdqIXpFDvB', '1', '迪迦奥特曼', 1, 'lixianhe/1699161670523.jpg');
INSERT INTO `video` (`id`, `key`, `hash`, `type`, `title`, `uid`, `cover`) VALUES (40, 'lixianhe/1699161716427.mp4', 'ltEUzzgJv_yi0o6RaUV6pW7NvIbf', '1', '数码宝贝', 1, 'lixianhe/1699161716427.jpg');
INSERT INTO `video` (`id`, `key`, `hash`, `type`, `title`, `uid`, `cover`) VALUES (41, 'lixianhe/1699161764024.mp4', 'llgTIqiy4nm2t0lb-keLS4ROPaaP', '1', '猫和老鼠', 1, 'lixianhe/1699161764024.jpg');
INSERT INTO `video` (`id`, `key`, `hash`, `type`, `title`, `uid`, `cover`) VALUES (42, 'lixianhe/1699161798599.mp4', 'ljBEplvumLtbT-PizW76fWAedvXr', '1', '喜羊羊与灰太狼', 1, 'lixianhe/1699161798599.jpg');
INSERT INTO `video` (`id`, `key`, `hash`, `type`, `title`, `uid`, `cover`) VALUES (43, 'lixianhe/1699161809967.mp4', 'ljcAwmzJWeO8CedmS3mP2pccdtOP', '1', '海绵宝宝', 1, 'lixianhe/1699161809967.jpg');
INSERT INTO `video` (`id`, `key`, `hash`, `type`, `title`, `uid`, `cover`) VALUES (44, 'lixianhe/1699161844286.mp4', 'lk7civRe-gQfIRtn-jCzXAe2-BC_', '1', '140部00后记忆中的经典动画片', 1, 'lixianhe/1699161844286.jpg');
INSERT INTO `video` (`id`, `key`, `hash`, `type`, `title`, `uid`, `cover`) VALUES (45, 'lixianhe/1699161870203.mp4', 'Frqq7DTnnpl38fyyvRSi_ywlmVA8', '10', '一二布布', 1, 'lixianhe/1699161870203.jpg');
INSERT INTO `video` (`id`, `key`, `hash`, `type`, `title`, `uid`, `cover`) VALUES (46, 'lixianhe/1699161872655.mp4', 'lhe19NRDLUcyZjGW609Zl2WCPEA6', '10', '一二布布08', 1, 'lixianhe/1699161872655.jpg');
INSERT INTO `video` (`id`, `key`, `hash`, `type`, `title`, `uid`, `cover`) VALUES (47, 'lixianhe/1699161876570.mp4', 'Fg2mr9-z9aWBsq9n-1P9kCserlG2', '10', '一二布布09', 1, 'lixianhe/1699161876570.jpg');
INSERT INTO `video` (`id`, `key`, `hash`, `type`, `title`, `uid`, `cover`) VALUES (48, 'lixianhe/1699161877340.mp4', 'FlcPQl0LEv3pqpF5Ev6s4easQ80n', '10', '一二布布02', 1, 'lixianhe/1699161877340.jpg');
INSERT INTO `video` (`id`, `key`, `hash`, `type`, `title`, `uid`, `cover`) VALUES (49, 'lixianhe/1699161878267.mp4', 'FpUuWw9M6eR_Tkb7NCvDQNAmOfEq', '10', '一二布布03', 1, 'lixianhe/1699161878267.jpg');
INSERT INTO `video` (`id`, `key`, `hash`, `type`, `title`, `uid`, `cover`) VALUES (50, 'lixianhe/1699161878774.mp4', 'ltpNYDvAx_uHegN2tCwKkivZ3tcU', '10', '一二布布15', 1, 'lixianhe/1699161878774.jpg');
INSERT INTO `video` (`id`, `key`, `hash`, `type`, `title`, `uid`, `cover`) VALUES (51, 'lixianhe/1699161884036.mp4', 'lgYOpGBEUlbFWEQsdrKizM59Ej_v', '10', '一二布布01', 1, 'lixianhe/1699161884036.jpg');
INSERT INTO `video` (`id`, `key`, `hash`, `type`, `title`, `uid`, `cover`) VALUES (52, 'lixianhe/1699161887718.mp4', 'FpFJ7Ll37SZxmLCDaZfawvcfIJkx', '10', '一二布布14', 1, 'lixianhe/1699161887718.jpg');
INSERT INTO `video` (`id`, `key`, `hash`, `type`, `title`, `uid`, `cover`) VALUES (53, 'lixianhe/1699161895281.mp4', 'lopUoAZs6zKmmYs3vGtBpm4Eck6I', '10', '一二布布10', 1, 'lixianhe/1699161895281.jpg');
INSERT INTO `video` (`id`, `key`, `hash`, `type`, `title`, `uid`, `cover`) VALUES (54, 'lixianhe/1699161899007.mp4', 'lstgRdVs1HIxYUP16_qOxsTmIQ0S', '10', '一二布布04', 1, 'lixianhe/1699161899007.jpg');
INSERT INTO `video` (`id`, `key`, `hash`, `type`, `title`, `uid`, `cover`) VALUES (55, 'lixianhe/1699161904222.mp4', 'ltI5HBDHBfEd-wan8In4IA8OQ5Y6', '10', '一二布布05', 1, 'lixianhe/1699161904222.jpg');
INSERT INTO `video` (`id`, `key`, `hash`, `type`, `title`, `uid`, `cover`) VALUES (56, 'lixianhe/1699161909123.mp4', 'lhYbBfKBBXsU-q-A-YVfr9FkhxMc', '10', '一二布布11', 1, 'lixianhe/1699161909123.jpg');
INSERT INTO `video` (`id`, `key`, `hash`, `type`, `title`, `uid`, `cover`) VALUES (57, 'lixianhe/1699161912631.mp4', 'lqkadXNgtK4q2guOF7j_o0pVyi67', '10', '一二布布07', 1, 'lixianhe/1699161912631.jpg');
INSERT INTO `video` (`id`, `key`, `hash`, `type`, `title`, `uid`, `cover`) VALUES (58, 'lixianhe/1699161915530.mp4', 'ljRugFEVG_bpHUiJvuhFdlbtXQmk', '10', '一二布布13', 1, 'lixianhe/1699161915530.jpg');
INSERT INTO `video` (`id`, `key`, `hash`, `type`, `title`, `uid`, `cover`) VALUES (59, 'lixianhe/1699161920877.mp4', 'lsDny8LhqXDHlqhhvlbFMeBMGUiP', '10', '一二布布12', 1, 'lixianhe/1699161920877.jpg');
INSERT INTO `video` (`id`, `key`, `hash`, `type`, `title`, `uid`, `cover`) VALUES (60, 'lixianhe/1699161928998.mp4', 'lpLqaN4hU8ssJp2uujslLob4k_Er', '10', '一二布布06', 1, 'lixianhe/1699161928998.jpg');
INSERT INTO `video` (`id`, `key`, `hash`, `type`, `title`, `uid`, `cover`) VALUES (61, 'lixianhe/1699161934526.mp4', 'lo7MMLtmGbKmQkWcIub7yO0L5_HH', '8', '植物大战僵尸04', 1, 'lixianhe/1699161934526.jpg');
INSERT INTO `video` (`id`, `key`, `hash`, `type`, `title`, `uid`, `cover`) VALUES (62, 'lixianhe/1699161956592.mp4', 'lkdy-19g1FBU7m9QxgR_TtKAihCY', '8', '植物大战僵尸05', 1, 'lixianhe/1699161956592.jpg');
INSERT INTO `video` (`id`, `key`, `hash`, `type`, `title`, `uid`, `cover`) VALUES (63, 'lixianhe/1699162076175.mp4', 'loUqG5A8Z9-bN2SYPAKhap2PinnU', '8', '植物大战僵尸07', 1, 'lixianhe/1699162076175.jpg');
INSERT INTO `video` (`id`, `key`, `hash`, `type`, `title`, `uid`, `cover`) VALUES (64, 'lixianhe/1699162188403.mp4', 'FrKWgRwKQXQz_nbMI4TfotDH7TxV', '8', '植物大战僵尸06', 1, 'lixianhe/1699162188403.jpg');
INSERT INTO `video` (`id`, `key`, `hash`, `type`, `title`, `uid`, `cover`) VALUES (65, 'lixianhe/1699162189668.mp4', 'lqe93pl6y8e0GoOewF70NMHl7G9K', '8', '植物大战僵尸02', 1, 'lixianhe/1699162189668.jpg');
INSERT INTO `video` (`id`, `key`, `hash`, `type`, `title`, `uid`, `cover`) VALUES (66, 'lixianhe/1699162226359.mp4', 'lrIIs7ucfzY2Dn93SMFFFigRevno', '8', '植物大战僵尸03', 1, 'lixianhe/1699162226359.jpg');
INSERT INTO `video` (`id`, `key`, `hash`, `type`, `title`, `uid`, `cover`) VALUES (67, 'lixianhe/1699162352354.mp4', 'lgndAdayiyn5oHO2T5PhR2ODHaTX', '8', '植物大战僵尸01', 1, 'lixianhe/1699162352354.jpg');
INSERT INTO `video` (`id`, `key`, `hash`, `type`, `title`, `uid`, `cover`) VALUES (68, 'lixianhe/1699162428620.mp4', 'ltpM59j1EO-kAojKB8-tI_low8lD', '8', ' 王者荣耀02', 1, 'lixianhe/1699162428620.jpg');
INSERT INTO `video` (`id`, `key`, `hash`, `type`, `title`, `uid`, `cover`) VALUES (69, 'lixianhe/1699162521896.mp4', 'lojZtpgd_eWZXV2FTdk2n6ziW7AF', '8', ' 王者荣耀03', 1, 'lixianhe/1699162521896.jpg');
INSERT INTO `video` (`id`, `key`, `hash`, `type`, `title`, `uid`, `cover`) VALUES (70, 'lixianhe/1699162737469.mp4', 'lnVg9SJa9pqWvL_aUj4JK34xPJtS', '8', ' 王者荣耀01', 1, 'lixianhe/1699162737469.jpg');
INSERT INTO `video` (`id`, `key`, `hash`, `type`, `title`, `uid`, `cover`) VALUES (71, 'lixianhe/1699162865960.mp4', 'lu2OQzKgsqkIOQpEEwHzg8gjWkJ-', '8', '王者荣耀04', 1, 'lixianhe/1699162865960.jpg');
INSERT INTO `video` (`id`, `key`, `hash`, `type`, `title`, `uid`, `cover`) VALUES (72, 'lixianhe/1699162995602.mp4', 'lrpJjxBKYK9vuPUM14NInwt5gnlV', '8', '植物大战僵尸08', 1, 'lixianhe/1699162995602.jpg');
INSERT INTO `video` (`id`, `key`, `hash`, `type`, `title`, `uid`, `cover`) VALUES (73, 'lixianhe/1699163068129.mp4', 'ls3mOE-LDOCjhRmxm5ajgarMaQd6', '8', '植物大战僵尸09', 1, 'lixianhe/1699163068129.jpg');
INSERT INTO `video` (`id`, `key`, `hash`, `type`, `title`, `uid`, `cover`) VALUES (74, 'lixianhe/1699163151942.mp4', 'lvCuGblNgDMvr5eQvDWDvp4UmSnQ', '4', '五大体育运动历史第一', 1, 'lixianhe/1699163151942.jpg');
INSERT INTO `video` (`id`, `key`, `hash`, `type`, `title`, `uid`, `cover`) VALUES (75, 'lixianhe/1699163215922.mp4', 'lrAd8r_lc4M-0XMUxCieVbdcWj6X', '4', '足球和篮球谁是第一运动', 1, 'lixianhe/1699163215922.jpg');
INSERT INTO `video` (`id`, `key`, `hash`, `type`, `title`, `uid`, `cover`) VALUES (76, 'lixianhe/1699163250715.mp4', 'lvgR7dgK4jQd-NVV5lEWU3ONyzzc', '4', '世界八大运动', 1, 'lixianhe/1699163250715.jpg');
INSERT INTO `video` (`id`, `key`, `hash`, `type`, `title`, `uid`, `cover`) VALUES (77, 'lixianhe/1699163257659.mp4', 'lsA9mv1rct-NiPNonJnO9IHdhZ2T', '4', '亚运会马拉松', 1, 'lixianhe/1699163257659.jpg');
INSERT INTO `video` (`id`, `key`, `hash`, `type`, `title`, `uid`, `cover`) VALUES (78, 'lixianhe/1699163288531.mp4', 'lrFkskoFiHlBxCGqdhxvbn_6cAZ2', '4', '天下跑姿第一人', 1, 'lixianhe/1699163288531.jpg');
INSERT INTO `video` (`id`, `key`, `hash`, `type`, `title`, `uid`, `cover`) VALUES (79, 'lixianhe/1699163327995.mp4', 'lmteQ8DC3rG24UI94wcZSG3jzoJM', '4', '奥运会史上最经典一幕', 1, 'lixianhe/1699163327995.jpg');
INSERT INTO `video` (`id`, `key`, `hash`, `type`, `title`, `uid`, `cover`) VALUES (80, 'lixianhe/1699163368017.mp4', 'ljK9C_3Q_-Q-5SzLJHWhbxhkp0OQ', '3', '你写程序开外挂吗', 1, 'lixianhe/1699163368017.jpg');
INSERT INTO `video` (`id`, `key`, `hash`, `type`, `title`, `uid`, `cover`) VALUES (81, 'lixianhe/1699163388204.mp4', 'liZ_rWQIM-4TPzIJW9AVm6dO1hJG', '3', '某个公司服务器每天晚上十点自动断开', 1, 'lixianhe/1699163388204.jpg');
INSERT INTO `video` (`id`, `key`, `hash`, `type`, `title`, `uid`, `cover`) VALUES (82, 'lixianhe/1699163426049.mp4', 'lqHs9orWG2cTEDMzLVW8hl1u9-g6', '12', '西虹市首富', 1, 'lixianhe/1699163426049.jpg');
INSERT INTO `video` (`id`, `key`, `hash`, `type`, `title`, `uid`, `cover`) VALUES (83, 'lixianhe/1699163433810.mp4', 'ltojSNoWFNrS7s-VWVFCRCEOm72H', '12', '迷离时空', 1, 'lixianhe/1699163433810.jpg');
INSERT INTO `video` (`id`, `key`, `hash`, `type`, `title`, `uid`, `cover`) VALUES (84, 'lixianhe/1699163478407.mp4', 'Fhq7G3fxrRO_PkU2CJuskIyF1ZOT', '12', '大时代', 1, 'lixianhe/1699163478407.jpg');
INSERT INTO `video` (`id`, `key`, `hash`, `type`, `title`, `uid`, `cover`) VALUES (85, 'lixianhe/1699163480216.mp4', 'lrRNrI_lns8LFCJVjRNCnNudpfo5', '12', '溥仪', 1, 'lixianhe/1699163480216.jpg');
INSERT INTO `video` (`id`, `key`, `hash`, `type`, `title`, `uid`, `cover`) VALUES (86, 'lixianhe/1699163985767.mp4', 'ln1vKceq3EvaojbQF322d_F0yXo7', '2', '盘点猝不及防的爆笑瞬间01', 1, 'lixianhe/1699163985767.jpg');
INSERT INTO `video` (`id`, `key`, `hash`, `type`, `title`, `uid`, `cover`) VALUES (87, 'lixianhe/1699164059267.mp4', 'lhUzYT1Mx_A9qlepm83VZ7_0HRUC', '2', '盘点猝不及防的爆笑瞬间03', 1, 'lixianhe/1699164059267.jpg');
INSERT INTO `video` (`id`, `key`, `hash`, `type`, `title`, `uid`, `cover`) VALUES (88, 'lixianhe/1699164189699.mp4', 'ltTIQzMZua7J1q5Hs8pWqohOKsf5', '2', '盘点猝不及防的爆笑瞬间02', 1, 'lixianhe/1699164189699.jpg');
INSERT INTO `video` (`id`, `key`, `hash`, `type`, `title`, `uid`, `cover`) VALUES (89, 'lixianhe/1699164298354.mp4', 'lkN8SozoDvMfY5ExygqoqjTmEwE5', '2', '盘点猝不及防的爆笑瞬间06', 1, 'lixianhe/1699164298354.jpg');
INSERT INTO `video` (`id`, `key`, `hash`, `type`, `title`, `uid`, `cover`) VALUES (90, 'lixianhe/1699164368114.mp4', 'lrdN1NW9HXnq-Wg7abfbB4wowEPJ', '2', '盘点猝不及防的爆笑瞬间07', 1, 'lixianhe/1699164368114.jpg');
INSERT INTO `video` (`id`, `key`, `hash`, `type`, `title`, `uid`, `cover`) VALUES (91, 'lixianhe/1699164463430.mp4', 'lnVuWPxOt0GF0s76i-ykEOrc_ECT', '2', '盘点猝不及防的爆笑瞬间05', 1, 'lixianhe/1699164463430.jpg');
INSERT INTO `video` (`id`, `key`, `hash`, `type`, `title`, `uid`, `cover`) VALUES (92, 'lixianhe/1699164638531.mp4', 'lpjBeICPwBl4wpgB0Em0TD6loHKP', '2', '盘点猝不及防的爆笑瞬间04', 1, 'lixianhe/1699164638531.jpg');
INSERT INTO `video` (`id`, `key`, `hash`, `type`, `title`, `uid`, `cover`) VALUES (93, 'lixianhe/1699164726593.mp4', 'lsJxEOYMiJ6CWU-vDQ-qNoth9UON', '5', '西柚冰茶妆', 1, 'lixianhe/1699164726593.jpg');
INSERT INTO `video` (`id`, `key`, `hash`, `type`, `title`, `uid`, `cover`) VALUES (94, 'lixianhe/1699165610478.mp4', 'lve7BizgThu-gJvHDIgB1mQGLcJK', '5', '香味', 1, 'lixianhe/1699165610478.jpg');
INSERT INTO `video` (`id`, `key`, `hash`, `type`, `title`, `uid`, `cover`) VALUES (95, 'lixianhe/1699165647879.mp4', 'lrflbAyxfDoC1x3hQ5w_HEVnCzEp', '5', '彩妆好物大分享', 1, 'lixianhe/1699165647879.jpg');
INSERT INTO `video` (`id`, `key`, `hash`, `type`, `title`, `uid`, `cover`) VALUES (96, 'lixianhe/1699180635675.mp4', 'Fq5OVvtFx2r9W1mWpD5GtKja0ETw', '9', '1', 1, 'lixianhe/1699180635675.jpg');
INSERT INTO `video` (`id`, `key`, `hash`, `type`, `title`, `uid`, `cover`) VALUES (97, 'lixianhe/1699181509351.mp4', 'Fq5OVvtFx2r9W1mWpD5GtKja0ETw', '9', 'echarts', 4, 'lixianhe/1699181509351.jpg');
INSERT INTO `video` (`id`, `key`, `hash`, `type`, `title`, `uid`, `cover`) VALUES (98, 'lixianhe/1699183342650.mp4', 'Fq5OVvtFx2r9W1mWpD5GtKja0ETw', '9', 'echarts', 5, 'lixianhe/1699183342650.jpg');
COMMIT;

SET FOREIGN_KEY_CHECKS = 1;
